-- @author lixiyong01
-- @date 20240710
-- app统计标签量级的分布

use hdp_lbg_supin_zplisting;

insert overwrite table app_hism_host_used_report partition (dt='${RUNDATE}')
select
    report_date,
    genres_cnt,
    count(distinct movie_id) as dist_cnt
from hdp_lbg_supin_zplisting.dws_hism_movielens_links
where dt = '${RUNDATE}'
group by genres_cnt;
